USE [eLogitics]
GO

/****** Object:  UserDefinedFunction [dbo].[GeDataDictionary]    Script Date: 04/17/2012 10:26:22 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GeDataDictionary]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[GeDataDictionary]
GO

USE [eLogitics]
GO

/****** Object:  UserDefinedFunction [dbo].[GeDataDictionary]    Script Date: 04/17/2012 10:26:22 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date, ,>
-- Description:	<Description, ,>
-- =============================================
Create FUNCTION [dbo].[GeDataDictionary]
(
	-- Add the parameters for the function here
	@OID uniqueidentifier
)
RETURNS nvarchar(50)
AS
BEGIN

declare @Name nvarchar(50)
set @Name =  ( select Name from Dictionary where OID=@OID)


return @Name

END


GO


